<?php
/**
 * Created by PhpStorm.
 * User: Guangpeng Chen
 * Date: 11-12/0012
 * Time: 14:07
 */
include '/var/www/html/new/conf/le.je';
$le = new go_sql();
$le->connect();
$sql="select l.id as lid,l.salerid,l.title as ltitle,t.id as tid,t.title as ttitle,t.pid,f.id as fid
      from uu_land l left join uu_jq_ticket t on l.id=t.landid left join uu_land_f f on f.tid=t.id where l.apply_did=94 ORDER BY l.addtime DESC";
$res=$le->query($sql);
while($row=$le->fetch_assoc($res)){
//    $lists[]=$row;
    $pids[] = $row['pid'];
    $fids[] = $row['fid'];
    $tids[] = $row['tid'];
    $lids[] = $row['lid'];
    $sids[] = $row['salerid'];
}

print_r(array_unique($sids));